jhCTLGFVER ($VER: TurboCalc.catalog 35.0 (07.10.95) english Sheet01 =TurboCalcDemo V3.5 1993-95 M.Friedrich - AREXX-Port: TCALC FTurboCalc V3.5 1993-95 by M.Friedrich - RECORDING... (Stop via Menu!) ETurboCalc V3.5 1993-95 by M.Friedrich - PLAYING... (Stop via Menu!) TurboCalc Michael Friedrich 5TurboCalc - AutoSave running: Saving current Sheet... free C_ancel _Continue _Save _Close _Print Pre_view _Font _File _Screen .info Open... Save as... Select Filename... z########################################################################################################################## TurboCalc-Help M.Friedrich S:TurboCalc.CFG S:TurboCalc.LRU 1Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec UJANUARY FEBRUARY MARCH APRIL AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER FALSE #ERROR #DIV/0 #VERSION #REFERENCE #)-BRACKET #TYPE #CELL #PARAMETER #(-BRACKET #SEMICOLON #VALUE #EOLINE AUTOMATIK AUTOMATIC DATABASE CRITERIA PRINTRANGE Color-Options Colors Default Background: Textcolor: == PRESS RETURN == !_Change colors on own screen only Help/ FALSE FALSCH FALSCH TurboCalcHELP: TurboCalc.guide Index.guide Menu.guide Functions.guide Macros.guide Tutorial.guide Topics.guide Remove Cells Insert Cells _Delete complete _Columns complete _Rows Block _left Block _up _Block right Block _down Clear Contents Insert Contents Forma_t only _Formulas only _Contents only _Formulas _Values Change Rowheight Please enter rowheight in lines Change Columnwidth !Please enter columnwidth in chars Set Variable Name: Cont.: _normal Data_Base _Criteria _Macro Protection _Writeprotection enabled Hide _formulas Alignment: Vertical Horizontal _Default _Left _Right _Centered Defaul_t _Middle Do_wn Multi_ple Lines Numeric Format: _Numeric -> 1_e+3 -> 7.25_% -> _Currency -> _Date -> _Time -> Redisplay _Sheet-SmartRefresh _Chart-SmartRefresh !(This speeds up the redisplaying, !but therefore uses more memory!) Goto Cell/Block: Compare _Part _Case Sensitivity Text: Sorting Sort Data Direction _Rows _Columns _Ascending _Descending by Column/Row: Create Series Data in Increment: Datatype _arithmetically _geometrically _Weekday _Month _Year Insert Macro: Start Macro Macro-Recording Macroname: Write macro to separate _Macro-Sheet this _Sheet Position _next free Column to _Cell: !Save Cursormovements _relatively Insert Variable Insert Formula: Frame: Around _Block Left: Right: Bottom: thin medium thick Set Font _Bold _Italic _Underlined Display-Options: Show _Grid Show _Titles Show Toolbar (_Icons) !Show _Formulas instead of Values Show _Zero Display _cursor as a frame Sheet-Options: _Calculation: manual : _Move Cursor: Create _Icons max. Sheetsize Width (<=18278) Height (<999999) Protection-flags &Please enter the Password for changing the Protection-flags: _Protect "protected" Cells. !Need Password to _open this file: read only: read/write: -Password for future changes of these options: Sheet is Password-Protected =This sheet is password-protected. Please enter the Password. Locale-Options Numeric Format Dec.-_Point (1.23) Dec.-Comm_a (1,23) _Comma (1,200) P_oint (1.200) Apost_rophe (1'200) _Underscore (1_200) _Space (1 200) Separator 30_.09.93 30_-09-93 30_/09/93 Order _DD.MM.YY _MM.DD.YY _YY.MM.DD Currency Prefix...Suffi_x M_easure: cm M_easure: inch Depth Smartopen Drag&Drop Execute your Drag&Drop? When saving en_crypt with: Sheet is Encrypted IThis sheet has been encrypted! Please enter the password for decryption. EYour entered password is wrong! Please try again or click on Cancel: Save Options %Keep previous _version of file (.BAK) Autosave _Ok, interval (min): #_write to the same directory (.TMP) Global Settings Show Status_line AutoOpen-Directory: 5_Drag&Drop: off _Drag&Drop: on _Drag&Drop: ask first 'Save _list of last recently used sheets AutoOpen use _Asl-Fontrequester Shift References Type: _all references _relative only _absolute only Offset Columns: Rows: Clipboard Settings Clipboard Unit O_Quotation marks: never _Quotation marks: if necessary _Quotation marks: always e_Delimiter: Tab _Delimiter: Comma _Delimiter: Semicolon _Delimiter: Space _Delimiter: multiple Spaces DataBase Requester New (_X) _Delete _Undo _Close _Next _Previous Print-Preview Page 001 use special Preview-Screen Select Preview-Screen _Category: All _Category: Math _Category: Trigonometry _Category: Boolean _Category: String _Category: Date & Time _Category: Database _Category: Sheets _Category: Range _Category: Financial _Category: Miscellaneous _Category: All _Category: Range _Category: Format _Category: Options _Category: Load/Save _Category: Macros _Category: Input _Category: Cell Selection _Category: Screen _Category: Command _Category: Database Select the datatype TurboCalc-Format Excel 4-Format (XLS) Lotus 123 (WKS) Sylk-Format ProCalc-Format CSV (Tab) CSV (Comma) CSV (Semicolon) CSV (Space) Save _Cursorposition 5_Cell Default: protected _Cell Default: unprotected _Fast Drawing redraw _damaged areas only !Load _Pictures using `Datatypes' Size (%) Show Chart... NoName... Show Sheet... Y Axis Requester Show _Y-Axis _Logarithmic Range _Min: _Horizontal Line H_orizontal Line Show _Values _Show Ticks Sho_w Sub-Ticks Ticks Sub-Ticks Number Axis Text Requester Show _Axis Labeling _use texts from the sheet following _texts: texts from _block: Legend Requester Show _Legend frame _no frame _simple frame shaded Fra_me Position _right l_eft _use texts from the sheet Color and Pattern _Patterns _both _userdefined: Print Chart _Maximal _Size (cm): _Size (inch): Width Height _Centered _Vertical Chart-Title Header: 2nd Header: Footer: Data Order Chart Range Chart Requester Type of Chart jDefault Column Point Hi-Lo Drawing 3D-Column 3D-Bar 3D-Pie 3D-Area 3D-Line Stacking _normal (no stacking) _stacked (sum) stacked (_percentage) Offset n_o Gap _1/2 Gap No_rmal Gap show _Values ( in _percent ) _3D-Look over_lapping _connected _Symbols _Values _Vert. Line 3changing Rectangle Circle Rhomb Triangle1 Triangle2 K_Refresh: manual _Refresh: when activating chart _Refresh: on recalculation Print sheet in file _File... Format of the IFF-Picture 'Save: IFF-Picture'-Format Width Height Depth Scale X Axis Requester Show _X-Axis Object Create New Object Object Parameter Object: Graphical Element Object: Text Object: Picture Frame 3_D-2 _Macro Put Object behind _cells %Object _protected (Protection flags) _Color... _Background... _Object... ?_Object: do not show _Object: Frame only _Object: show normally eIf you remove this Chart, the appropiate objects will be deleted, too! (Otherwise use .) Remove Chart Preview 7_Corner: u.l. _Corner: u.r. _Corner: l.l. _Corner: l.r. _normal filled filled, outlined Picture-Margins Left: Right: Bottom: _Refresh picture: from _Clipboard %Only save reference to the _picture. Create Chart-Object ~To create a Chart-Object: * Create chart with as usual * Select in the chart-window * (Optionally) select . 1The sheet the chart was taken from is not opened! *To display this picture you'll need OS2.0. No filename given. Couldn't open file. File is no IFF-ILBM-File. IFF-File is corrupt. Out of memory! Read-Error! Chart Gel - Graphical Element Iff-Graphic Rectangle Square Ellipse Triangle Cross Arrow 1 Arrow 1 - diag. Arrow 2 Arrow 2 - diag. Arrow 3 Arrow 3 - diag. Arrow 4 Arrow 4 - diag. Output _Text _Graphic Scale % Density Printing... Printing Page # 001... Printing Skipping LinesPerInch _6 lpi _8 lpi Quality _Draft Style _Pica E_lite _Condensed Print Range _Page _Color-Print _Wait for new Page _Vertical Papersize A_4 normal (21*29.7) A4 _fanfold (21*30.5) A_3 normal (29.7*42) C_ustom (cm) C_ustom (inch) Width Height Gfx-_Prefs... Pri_nt Layout... _Paper Format... use _Formfeed !(%P = Page, %D = Date, %N = Name) Header/Footer _Head _Foot Print Sheet Print-Layout Paper-Format P_rinter File: Margins (in cm) Margins (in inch) right bottom _Titles )no _Grid _Grid (Line) _Grid (Underlined) Printer Prefs Print Range defined Print _Range currently _marked Range to _Clipboard !TurboCalcDemo V3.5 M.Friedrich ~~Version 3.51E - 07.10.95 ARexx-Port & PubScreen: 'TCALC' written 1993-95 by - Michael Friedrich - Creative Developments All Rights reserved. Digita International is the exclusive word-wide publisher of TurboCalc in English. TurboCalc-Info 2~TurboCalc 1993-95 Michael Friedrich Version: Revision: Name: Number: Number of open sheets: Chip-Mem: Fast-Mem: Close Sheet? OIf you close this window your modified sheet will be lost! Save before closing? Quit TurboCalc? IIf you close this window, you will quit TurboCalc as well. Are you sure? /Are you sure you really want to quit TurboCalc? Height Text: right: Change Gadget Macro-Message: Macro-Question: Macro-Dialogue: %Please enter text (for cellcontents): Message: TurboCalc-Command %Please enter your TurboCalc-Command: Textinput: Please enter your data: Choose Screenmode: r~Please enter your desired screen-mode as WIDTH,HEIGHT,DEPTH,"SCREENMODE". (Depth and/or Screenmode are optional.) Set Font ;Please enter your desired font as Font/Size (e.g. topaz/8). Load/Save: JThis is the Demo~version of TurboCalc - this command isn't available here. #TurboCalc-Demoversion M.Friedrich ~This is the demo~version of TurboCalc (E). Saving and printing is not possible! For more details and how to order the full version please read the file 'Read.Me'. TurboCalc-Error: Database-Find: *Too many para~meters for this instruction! &Wrong para~meter for this instruction! Command not found! !Syntax-Error in this instruction! 2This command can't be used for "protected" sheets! FThis sheet is "read only" and thus can't be modified! Command aborted! KThe window where you started this command has been closed! Command aborted! 5No block selected! Please select block and try again. Read-Error! Reading is aborted. FWrite-Error! (Perhaps disk-full or write-protected!). Writing aborted! %File couldn't be opened for reading! %File couldn't be opened for writing! 5No block marked! Please select a block and try again! RFor Find, Extract und Delete you have to define Database- und Criteriarange first! OFor Find, Extract, Delete and Sort you have to define the Database-range first! Error in Criteria detected! ]Warning: Next "Extract" would have destroyed Criteria- or Databaserange. Extracting aborted! No match found! 1No more matching text! Continue at the beginning? !Wrong password - command aborted! =Marked block is no square (Width=Height)! Trans~pose failed. 3Help not available! File TurboCalc.guide not found. -The desired font couldn't be found or loaded! %You can't hide the last sheet-window! OPrinter couldn't be opened! (If you selected "File", then check your filename!) FPrint-Page is too small - printing is impossible! Please check layout! UNTIL without a pervious LOOP! RETURN in a LOOP...UNTIL-loop! no ENDIF found! #second ELSE found (ENDIF expected)! Macro-Error: There's a macro-error in cell Continue Macro? Macro-STEP-Mode Next macro-command in cell with the command: Execute command? UThis command isn't implemented yet. It is reserved for the next version of TurboCalc! .To execute this command you need OS2.0. Sorry! 9This command can't be executed when a object is selected! 1Cannot execute this command: No object selected! "Incompatible size of the matrices. 6Couldn't open rexxsys.library or Rexx not yet started. 2Clipboard-Error: Couldn't open 'iffparse.library'. )Clipboard-Error: Couldn't open clipboard. 'Clipboard-Error during reading/writing. ECouldn't open 'amigaguide.library'. (Version >=37 (OS3.x) necessary.) Couldn't open AmigaGuide-File. New Page! IPlease insert new sheet of paper and click . stops printing. Printing... Read/Write-Error Printer couldn't be opened! CPrinter is offline - please check printer ("Online") and try again! 9Printer out of paper! Please insert paper and try again! )Couldn't open the file, an error occured! gCouldn't open the file, an error occured!If Disk is write protected, remove this protection! Try again? Working... Click to execute command Click and drag to change width Click and drag to change height Click to edit contents Move the block Copy the block Change the blocksize Goto: Select to be marked range New: Create a new, empty sheet Open: Load a saved sheet +Save: Save the sheet under the current name Print: Print the current sheet *Font: Change the font of the current range >Normal: Remove all special attributes of the current type-face *Bold: Change the current type-face to bold .Italic: Change the current type-face to italic 6Underlined: Change the current type-face to underlined 7Left Aligned: Left align the texts of the current cells /Centered: Center the texts of the current cells 9Right Aligned: Right align the texts of the current cells -Color: Change the color of the current range +Cut: Cut the current block to the clipboard -Copy: Copy the current block to the clipboard 9Paste: Paste cut or copied data to the current cell/block >Generate Series: Fill the current block with calculates series Sort: Sort the current block CGenerate Chart: Use the data of the current block to create a chart ;Insert Formula: Select a formula and insert in current cell CInsert Macro: Select a macro-instruction and insert in current cell /Start Macro: Execute one of the existing macros %Help: Start the TurboCalc help-system Goto: Select to be marked range New: Creates a new, empty sheet +SmartOpen: Load one of the last used sheets -Save as: Save the sheet asking for a new name %Preview: Show the printout on screen 9Font: Reset the font of the current range to the default >Normal: Remove all special attributes of the current type-face *Bold: Change the current type-face to bold .Italic: Change the current type-face to italic 6Underlined: Change the current type-face to underlined 5Top Aligned: Top align the texts of the current cells :Vertically Centered: Center the texts of the current cells ;Bottom Aligned: Bottom align the texts of the current cells BBackground-Color: Change the background-color of the current range +Cut: Cut the current block to the clipboard -Copy: Copy the current block to the clipboard 9Paste: Paste cut or copied data to the current cell/block >Generate Series: Fill the current block with calculates series "DB-Sort: Sort the current database >Create Object: Add a new object to the current cursor position ;Insert Formula: Select a formula and insert in current cell CInsert Macro: Select a macro-instruction and insert in current cell .Start Macro: Execute one of the defined macros %Help: Start the TurboCalc help-system MG@(Sheet;Range) G#Range AABS(Value) CAND(Value1;Value2) BARCCOS(Value) BARCSIN(Value) BARCTAN(Value) GAT(Sheet;Range) HAVERAGE(Range) GCELL(Row;Column) GCELLABS(Row;Column) JCELLINFO(Number;Cell) ICFV(PV;Rate;Term[;Freq]) DCHAR(Code) GCHOOSE(Index;Value1;Value2;Value3) DCLEAN(Text) DCODE(Text) GCOLUMNUMBER([Range]) DCOMPRESS(Text[;List]) BCOS(Value) BCOSHYP(Value) HCOUNT(Range) HCOUNT2(Range) ICTERM(PV;FV;Rate;[;Freq) EDATE(Year;Month;Day) EDATEVALUE(Text) EDAY(Date) FDAVERAGE(Database;Column;Criteria) FDCOUNT(Database;Column;Criteria) FDCOUNT2(Database;Column;Criteria) FDMAX(Database;Column;Criteria) FDMIN(Database;Column;Criteria) FDPRODUCT(Database;Column;Criteria) FDSTDEV(Database;Column;Criteria) FDSUM(Database;Column;Criteria) FDVAR(Database;Column;Criteria) BDEGTORAD(Value) JDEMOVERSION() AEXP(Value) AFAC(Value) CFALSE() JFILEEXISTS(File) IFV(Payment;Rate;Term[;Freq]) DHEX(Hextext) GHLOOKUP(Value;Range;Offset;[Exactly]) CIF(Condition;Value1;Value2) GINDIRECT(Text) JINFO(Value) DINSTRING(Text;Pattern[;Pos]) AINT(Value) AINTEGER(Value) ILRATE(PV;FV;Term[;Freq]) EISDATE(Value) CISEMPTY(Cell) CISERR(Cell) CISNUMBER(Value) CISSTRING(Value) CISTIME(Value) JLASTERROR() DLEFT(Text;Length) DLENGTH(Text) ALG(Value) ALN(Value) ALOG(Value) ALOG10(Value) GLOOKUP(Value;Range;[Exactly]) DLOWER(Text) HMAX(Range) DMID(Text;Start;Length) HMIN(Range) AMOD(Value1;Value2) EMONTH(Date) CNOT(Boolean) ENOW() JOBJECTINFO(Object;Nr) COR(Value1;Value2) DPART(Text;Start;Length) BPI() IPMT(FV;Rate;Term[;Freq]) HPRODUCT(Range) IPV(FV;Rate;Term[;Freq) BRADTODEG(Value) GRANGEABS(Row;Column;Height;Width) GRANGEHEIGHT(Range) GRANGEWIDTH(Range) GRANGEX(Range) GRANGEY(Range) DREPEAT(Text;Number) DREVERSE(Text) JREVISION() DRIGHT(Text;Length) ARND(Value) AROUND(Value;Digit) GROWNUMBER([Range]) JSETALIGNMENT(Cond;Val1;Val2[;Cell]) JSETCOLOR(Cond;Val1;Val2[;Cell]) JSETFORMAT(Cond;Val1;Val2[;Cell]) JSETSTYLE(Cond;Val1;Val2[;Cell]) GSHEETNAME() DSHIFTL(Text) DSHIFTR(Text) ASIGN(Value) BSIN(Value) BSINHYP(Value) ASQR(Value) ASQRT(Value) HSTDEV(Range) HSUM(Range) BTAN(Value) BTANHYP(Value) JTCFUNCTION(TCLib;Offset;Val1;Val2;String) ITERM(FV;Payment;Rate;[;Freq]) DTEXT(Data;Format) ETIMEVALUE(Text) ETODAY() DTRIM(Text) CTRUE() DUPPER(Text) DUPPER2(Text) DVALUE(Text) HVAR(Range) JVERSION() GVLOOKUP(Value;Range;Offset;[Exactly]) EWEEKDAY(Date) CXOR(Value1;Value2) EYEAR(Date) IABOUT() GACTIVATEWINDOW() AADD(Data;[Range]) HADDMENUITEM(Name;Cmd;[Title;Item]) HADDMENUSUB(Name;Cmd;[Title;Item;Sub]) HADDMENUTITLE(Name;[Title]) BALIGNMENT([Hor];[Ver];[Range]) IAMIGAGUIDE(File;[Command]) CAUTOSAVE() FBEEP() EBLOCKVARIABLE(Name;Range) BBOX(Left;Right;Up;Down;[Range]) ECALL(Cell) CCHANGECOLOR(Color;Red;Green;Blue) BCHANGESTYLE(Num;[Range]) HCHANGEWINDOW(X;Y;Width;Height) ICHARTSHOW() ACLEAR(Data;[Range]) CCLIPBOARD(Unit;Sep.;Quotes) DCLIPREAD([Range]) DCLIPWRITE([Range]) ICLOSESHEET(Now) BCOLORS([Color1];[Color2];[Range]) GCOLUMN(Column) BCOLUMNWIDTH(Width;[Range]) ICOMMAND() ACOPY([Range]) JCRITERIA([Range]) DCSVINSERT([Range];[Name];[SepChar]) DCSVLOAD([Name];[SepChar]) DCSVSAVE([Name];[SepChar]) DCSVSAVEBLOCK([Range];[Name];Char) GCURRENTCELL() ACUT([Range]) JDATABASE([Range]) JDBDELETE() JDBEXTRACT([Cell]) JDBFIND([Cell]) JDBMASK() JDBPREV([Cell]) JDBSORT(Direction;[Cell}) CDEFPUBSCREEN([Name]) FDELAY(Time) EDELETEVARIABLE(Name) HDELMENUITEM(Text;Item) HDELMENUSUB(Text;Item;Sub) HDELMENUTITLE(Text) EDIALOGUE(Range) CDISPLAY(Title;Raster;Tool;Formula;Zero) EDLGRESUME(Flag) GDOWN(Num) IEDIT() EEXECUTE(File;Parameter;[Window]) AFILL(Mode;[Range]) GFIND(Text;Part;Upper;Column;Range) BFONT([Num];[Font];[Range]) EFOR(Variable;Start;End;Step) CFORMFEED(Flag) EFORRANGE(Variable;Range;Flags) BFRAME(Left;Right;Up;Down;[Range]) BFREEZE(Cell) CGLOBALFLAGS() GGOTO(Cell) GGOTOCOLUMN(Column) GGOTOLINE(Row) IHELP(Num;[File]) BHIDE(Row;[Range]) IICONIFY() DIFFPRINT(File;Width;Height;Depth;[Range]) EIFGOTO(Cond;Cell) FINPUT(Text;[Title];[Cell]) FINSERTFORMULA() FINSERTMACRO() FINSERTNAME() HKEY(Key;Command) BLANGUAGE(Mode;[Range]) GLASTCOLUMN() GLASTROW() GLINE(Row) DLOAD(Name) DLOADCONFIG() CLOCALE(...) ELOOP() EMACRO(...) EMACROPLAY(Cell) BMADD(Range;Range;Range) EMELSE() EMENDIF() FMESSAGE(Text;[Title]) EMIF(Condition) BMMUL(Range;Range;Range) HMOVEWINDOW(X;Y) BMSUB(Range;Range;Range) HNEWMENU() INEWSHEET(Name) HNEWWINDOW() ENEXT() BNUMERICFORMAT(Format;[Range]) FOBJECT(Name;Type;TextPara;Val1;Val2;Range) FOBJECTCLASS(Name) COBJECTPARA(Name;Macro;M.-Enable;Color;Frame) COBJECTPOS(Name;X;Y;Breite;H FOBJECTSELECT(Name) COLDCOLORS() EONERROR([Cell]) COPENFLAGS(Automatic;Hidden;Password) CPAPERFORMAT() APASTE([Range]) APASTEDATA(Mode;[Range]) BPATTERN(Number;[Range]) HPOSWINDOW() HPOSWINDOW2() IPREVIEW() IPRINT(...) CPRINTFORMAT(...) CPRINTRANGE(Active;[Range]) DPROCALCINSERT([Range];[Name]) DPROCALCLOAD([Name]) CPROTECTFLAGS() BPROTECTION([Write];[Formular};[Range]) APUT(Contents;[Cell]) IQUIT([Mode]) IRECALC(Mode) IRECORD() IREDO() AREFERENCESHIFT(X;Y;Flags;Block) AREFERENCETYPE(Flags;Range) EREFRESH(Mode) AREMOVE(Data:[Range]) FREQPARA(X;Y;Ok;Abort;Time) FREQUEST(Text;[Title]) ERETURN() BROWHEIGHT(Height;[Range]) ERUN(File;Para;[Window]) ERX(File[;Port]) DSAVE([Name]) DSAVEAS([Name]) DSAVEBLOCK([Range];[Name]) DSAVECONFIG() CSCREEN(Width;Height;Depth;Mode) GSELECT([Range]) GSELECTSHEET(Name;[WindowNum]) ASERIES(Type;Inc;Column;Range) CSETFONT(Font;[Mode]) CSHANGHAI(Mode) CSHEETFLAGS(...) HSHEETHIDE(Sheet;Number) HSHEETSHOW(Sheet;Number) BSHOW(Cell;[Range]) HSHOWMENU() HSIZEWINDOW(Width;Height) DSMARTOPEN() CSMARTREFRESH(Mode) ASORT(Ascending;Direction;Cell;Range) ESTART(Filename) CSTDCOLORS() CSTDFONT(Font) ESTEP([Flag]) ISTOPRECORD() DSYLKINSERT([Range];[Name]) DSYLKLOAD([Name]) DSYLKSAVE(Name) DSYLKSAVEBLOCK([Range];[Name]) FSYSINFO() DTCDINSERT([Range];[Name]) ATRANSPOSE([Range]) EUNCHANGED() IUNDO() EUNTIL(Condition) GUP() EVARIABLE(Name;Value) EWHILE(Condition) HWINDOWTOBACK() HWINDOWTOFRONT()